CREATE TABLE [dbo].[tb_Divisionestemp]
(
[idDivision] [int] NOT NULL IDENTITY(1, 1),
[Mnemo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[idSubOrg] [int] NULL,
[Descripcion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EsGrupo] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Curso] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Division] [varchar] (13) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GrupoCarreras] [int] NOT NULL,
[Turno] [int] NOT NULL,
[FechaAlta] [datetime] NOT NULL,
[Baja] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FechaBaja] [datetime] NULL,
[CUISE] [int] NULL,
[EsPrivada] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Divpriv] [int] NULL,
[cargo] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hora] [datetime] NULL,
[divreal] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_Divisionestemp] ADD CONSTRAINT [PK_tb_Divisionestemp] PRIMARY KEY CLUSTERED  ([idDivision]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_Divisionestemp] WITH NOCHECK ADD CONSTRAINT [FK_tb_Divisionestemp_tb_Divisiones] FOREIGN KEY ([divreal]) REFERENCES [dbo].[tb_Divisiones] ([idDivision]) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[tb_Divisionestemp] WITH NOCHECK ADD CONSTRAINT [FK_tb_Divisionestemp_tb_GrupoDeCarreras] FOREIGN KEY ([GrupoCarreras]) REFERENCES [dbo].[tb_GrupoDeCarreras] ([idGrupoCarrera])
GO
ALTER TABLE [dbo].[tb_Divisionestemp] WITH NOCHECK ADD CONSTRAINT [FK_tb_Divisionestemp_tb_Turnos] FOREIGN KEY ([Turno]) REFERENCES [dbo].[tb_Turnos] ([idTurno])
GO
ALTER TABLE [dbo].[tb_Divisionestemp] NOCHECK CONSTRAINT [FK_tb_Divisionestemp_tb_Divisiones]
GO
